Tabela ExamHist

Definicja tabeli ExamHist

Name

ExamHist

Code

ExamHist

Comment

 


Lista kolumn tabeli ExamHist

Name

Code

ID

ID

ExtID

ExtID

PatID

PatID

HospID

HospID

ServiceID

ServiceID

RefDeptID

RefDeptID

RefDrID

RefDrID

DescrDrID

DescrDrID

Status

Status

PublishStatus

PublishStatus

RefDate

RefDate

SubTypeID

SubTypeID

Diagnosis

Diagnosis

Descr

Descr

RadCode1

RadCode1

RadCode2

RadCode2

RadCode3

RadCode3

Remarks

Remarks

PerfDate

PerfDate

PatAgeInDays

PatAgeInDays

OwnerID

OwnerID

UpdUserID

UpdUserID

UpdNr

UpdNr

UpdDate

UpdDate

UpdTime

UpdTime

LockUserID

LockUserID

LockTime

LockTime

FullAcc

FullAcc

ReadAcc

ReadAcc

PRIORYTETID

PRIORYTETID

SKIERID

SKIERID

PerfDeptID

PerfDeptID

PerfExtID

PerfExtID

Comments

Comments

ExamRecordTypeID

ExamRecordTypeID

AccNum

AccNum


Kolumna ID tabeli ExamHist

Definicja kolumny ID tabeli ExamHist

Name

ID

Code

ID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ExtID tabeli ExamHist

Definicja kolumny ExtID tabeli ExamHist

Name

ExtID

Code

ExtID

Data Type

VARCHAR2(16)

Mandatory

No

Comment

 


Kolumna PatID tabeli ExamHist

Definicja kolumny PatID tabeli ExamHist

Name

PatID

Code

PatID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna HospID tabeli ExamHist

Definicja kolumny HospID tabeli ExamHist

Name

HospID

Code

HospID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ServiceID tabeli ExamHist

Definicja kolumny ServiceID tabeli ExamHist

Name

ServiceID

Code

ServiceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna RefDeptID tabeli ExamHist

Definicja kolumny RefDeptID tabeli ExamHist

Name

RefDeptID

Code

RefDeptID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna RefDrID tabeli ExamHist

Definicja kolumny RefDrID tabeli ExamHist

Name

RefDrID

Code

RefDrID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna DescrDrID tabeli ExamHist

Definicja kolumny DescrDrID tabeli ExamHist

Name

DescrDrID

Code

DescrDrID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Status tabeli ExamHist

Definicja kolumny Status tabeli ExamHist

Name

Status

Code

Status

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna PublishStatus tabeli ExamHist

Definicja kolumny PublishStatus tabeli ExamHist

Name

PublishStatus

Code

PublishStatus

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna RefDate tabeli ExamHist

Definicja kolumny RefDate tabeli ExamHist

Name

RefDate

Code

RefDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna SubTypeID tabeli ExamHist

Definicja kolumny SubTypeID tabeli ExamHist

Name

SubTypeID

Code

SubTypeID

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Diagnosis tabeli ExamHist

Definicja kolumny Diagnosis tabeli ExamHist

Name

Diagnosis

Code

Diagnosis

Data Type

VARCHAR2(100)

Mandatory

No

Comment

 


Kolumna Descr tabeli ExamHist

Definicja kolumny Descr tabeli ExamHist

Name

Descr

Code

Descr

Data Type

CLOB

Mandatory

No

Comment

 


Kolumna RadCode1 tabeli ExamHist

Definicja kolumny RadCode1 tabeli ExamHist

Name

RadCode1

Code

RadCode1

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna RadCode2 tabeli ExamHist

Definicja kolumny RadCode2 tabeli ExamHist

Name

RadCode2

Code

RadCode2

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna RadCode3 tabeli ExamHist

Definicja kolumny RadCode3 tabeli ExamHist

Name

RadCode3

Code

RadCode3

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna Remarks tabeli ExamHist

Definicja kolumny Remarks tabeli ExamHist

Name

Remarks

Code

Remarks

Data Type

VARCHAR2(512)

Mandatory

No

Comment

 


Kolumna PerfDate tabeli ExamHist

Definicja kolumny PerfDate tabeli ExamHist

Name

PerfDate

Code

PerfDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna PatAgeInDays tabeli ExamHist

Definicja kolumny PatAgeInDays tabeli ExamHist

Name

PatAgeInDays

Code

PatAgeInDays

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna OwnerID tabeli ExamHist

Definicja kolumny OwnerID tabeli ExamHist

Name

OwnerID

Code

OwnerID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna UpdUserID tabeli ExamHist

Definicja kolumny UpdUserID tabeli ExamHist

Name

UpdUserID

Code

UpdUserID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna UpdNr tabeli ExamHist

Definicja kolumny UpdNr tabeli ExamHist

Name

UpdNr

Code

UpdNr

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna UpdDate tabeli ExamHist

Definicja kolumny UpdDate tabeli ExamHist

Name

UpdDate

Code

UpdDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna UpdTime tabeli ExamHist

Definicja kolumny UpdTime tabeli ExamHist

Name

UpdTime

Code

UpdTime

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna LockUserID tabeli ExamHist

Definicja kolumny LockUserID tabeli ExamHist

Name

LockUserID

Code

LockUserID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LockTime tabeli ExamHist

Definicja kolumny LockTime tabeli ExamHist

Name

LockTime

Code

LockTime

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna FullAcc tabeli ExamHist

Definicja kolumny FullAcc tabeli ExamHist

Name

FullAcc

Code

FullAcc

Data Type

RAW(255)

Mandatory

No

Comment

 


Kolumna ReadAcc tabeli ExamHist

Definicja kolumny ReadAcc tabeli ExamHist

Name

ReadAcc

Code

ReadAcc

Data Type

RAW(255)

Mandatory

No

Comment

 


Kolumna PRIORYTETID tabeli ExamHist

Definicja kolumny PRIORYTETID tabeli ExamHist

Name

PRIORYTETID

Code

PRIORYTETID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna SKIERID tabeli ExamHist

Definicja kolumny SKIERID tabeli ExamHist

Name

SKIERID

Code

SKIERID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PerfDeptID tabeli ExamHist

Definicja kolumny PerfDeptID tabeli ExamHist

Name

PerfDeptID

Code

PerfDeptID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PerfExtID tabeli ExamHist

Definicja kolumny PerfExtID tabeli ExamHist

Name

PerfExtID

Code

PerfExtID

Data Type

VARCHAR2(20)

Mandatory

No

Comment

 


Kolumna Comments tabeli ExamHist

Definicja kolumny Comments tabeli ExamHist

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna ExamRecordTypeID tabeli ExamHist

Definicja kolumny ExamRecordTypeID tabeli ExamHist

Name

ExamRecordTypeID

Code

ExamRecordTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna AccNum tabeli ExamHist

Definicja kolumny AccNum tabeli ExamHist

Name

AccNum

Code

AccNum

Data Type

VARCHAR2(64)

Mandatory

No

Comment